﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace QuanLySuKien.model
{
    public class Users
    {


        //lay userid by username
        public string GetUserIdByUsername(string username)
        { 
            DataAccess da = new DataAccess();
            string sql = "SELECT TOP(1) UserId FROM aspnet_Users WHERE UserName = '"+username+"'";
            return da.GetScalar(sql).ToString();
        
        }

    }
}